
var express = require('express');
var router = express.Router();
var dbcomm = require('../util/dbcomm');
var moment = require('moment');
var now = moment().format('YYYY年MM月DD日') ;//日期

router.get('/suppermenu',function(req,res){
    // console.log(req.session);
    var result = {};
    var sql = "SELECT * from sys_jurisdiction a left join sys_functioninformation b on b.functionNo = a.functionNo where a.roleNo = "+req.session.staffRole;
    dbcomm.query(sql,function(err,data){
        if(err) throw err;
        else{
            res.send(data);
        }
    });
})






module.exports = router;